alter proc [dbo].[SP_GET_APPOINTMENTS_EPLOYEE_BYDATE]  
( @APP_DATE datetime,
 @APP_STARTTIME DATETIME  
)  
AS  
select  EMP_ID,(EMP_FIRSTNAME +' '+ EMP_LASTNAME) AS FULLNAME,dbo.EMPLOYEES.EMP_ID  
from dbo.EMPLOYEES   
where EMP_ID NOT IN(  
 select APPOINTMENTS.EMP_ID from APPOINTMENTS   
where APP_STATUS!='DENY' AND APP_DATE=@APP_DATE AND APP_STARTTIME=@APP_STARTTIME)